home
***
CD-ROM
|
disk
|
FTP
|
other
***
search
/
Libris Britannia 4
/
science library(b).zip
/
science library(b)
/
MEDICAL
/
1752.ZIP
/
MHD.ZIP
/
MHSEARCH.PRG
< prev
next >
Wrap
Text File
|
1986-07-11
|
5KB
|
148 lines
* MHSEARCH DB3 PLUS REVISION 03/06/86
*
* Allows choice of searching
* MHORGAN.DBF for sensitive organisms,
* MHCLINIC.DBF for clinical criteria,
* MHCOMBIN.DBF for combining two or more search criteria,
* and displays results of search.
*
CLOSE DATABASES
PUBLIC search, search2, datafile, dofile, combsrch
repeat1 = .T.
repeat2 = .T.
repeat3 = .T.
choice = [ ]
combsrch = [ ]
DO WHILE repeat1
DO WHILE .NOT. choice $'012'
CLEAR
? 'SEARCH MENU'
? '0. RETURN TO PREVIOUS MENU..............'
? '1. SEARCH FOR ORGANISM SENSITIVITY......'
? '2. SEARCH FOR CLINICAL CRITERIA.........'
WAIT 'ENTER THE NUMBER OF YOUR CHOICE: ' TO choice
IF choice ='0'
RETURN
ENDIF choice = 0
ENDDO WHILE .NOT. choice $'012'
?
? 'Setting up working files. This will take a few moments...'
DO CASE
CASE choice = '1' .AND. .NOT. search2
* This is first search
search2 = .F.
* Select DBF file for organism search
datafile = 'MHORGAN'
* Select PRG file for organism search
dofile = 'MHSRORGN'
CASE choice = '2'.AND. .NOT. search2
* This is first search
search2 = .F.
* Select DBF file for clinical data search
datafile = 'MHCLINIC'
* Select PRG file for clinical data search
dofile = 'MHSRCLINIC'
CASE choice = '1' .AND. search2
* Limit search to data set from previous search stored in MHWORK1.DBF
* Select DBF file for organism search
datafile = 'MHORGAN'
SELECT B
USE &datafile
SELECT A
USE MHWORK1
JOIN WITH &datafile to MHCOMBIN FOR DRUG_ID=B->DRUG_ID FIELDS;
DRUG_ID, ORGANISM
datafile = 'MHCOMBIN'
* Select PRG file for organism search
dofile = 'MHSRORGN'
CASE choice = '2'.AND. search2
* Limit search to data set from previous search stored in MHWORK1.DBF
* Select DBF file for clinical data search
datafile = 'MHCLINIC'
SELECT B
USE &datafile
SELECT A
USE MHWORK1
JOIN WITH &datafile to MHCOMBIN FOR DRUG_ID=B->DRUG_ID FIELDS;
DRUG_ID, CLIN_DATA
datafile = 'MHCOMBIN'
* Select PRG file for organism search
dofile = 'MHSRCLINIC'
ENDCASE
* Branch to program file for search
DO &DOFILE
IF .NOT. search2
combsrch = search
ENDIF NOT search2
IF search2
combsrch = combsrch + ' and ' + search
ENDIF search2
repeat3 = .T.
DO WHILE repeat3
* Find and display data from DRUG.DBF for drug:id stored in WORK1
STORE 0 TO line
SELECT A
USE MHDRUG INDEX MHDRUGID
SELECT B
USE MHWORK1
GOTO TOP
CLEAR
@ line + 0, 0 SAY 'Drugs for ' + combsrch
******** TOP LINE *************************************************
@ line + 1, 0 SAY CHR(201) + SPACE(78) + CHR(187)
@ line + 1, 1 TO line + 1, 78 DOUBLE
******** LABEL LINE ***********************************************
@ line + 2, 0 SAY CHR(186)
SET COLOR TO I
@ line + 2, 1 SAY 'GENERIC NAME' + REPL(CHR(255),5) + 'CLASS';
+ REPL(CHR(255),11) + 'ROUTE' + REPL(CHR(255),4) + 'BRAND NAME';
+ REPL(CHR(255),21) + 'ID:NO'
SET COLOR TO
@ line + 2, 79 SAY CHR(186)
DO WHILE .NOT. EOF()
mdrug_id = DRUG_ID
SELECT A
FIND &mdrug_id
******** DATA LINE ***********************************************
@ line + 3, 0 SAY CHR(186) + GEN_NAME + ' ' + CLASS + ' '+ ROUTE;
+ ' ' + BR_NAME + ' ' + DRUG_ID + CHR(186)
STORE line + 1 TO line
IF line > 19
ACCEPT 'More data. Press RETURN to continue' TO waiting
CLEAR
line = -3
ENDIF line > 19
SELECT MHWORK1
SKIP
ENDDO WHILE NOT EOF
******* BOTTOM LINE ***********************************************
@ line + 3, 0 SAY CHR(200) + SPACE(78) + CHR(188)
@ line + 3, 1 TO line + 3, 78 DOUBLE
? ' 0. Return to main menu'
? ' 1. Review one specific drug'
? ' 2. Review all the drugs listed'
? ' 3. Repeat listing of drugs for ' + combsrch
? ' 4. Combine ' + combsrch + ' with another search'
WAIT 'Enter the number of your choice: ' TO select
DO CASE
CASE select = '0'
RETURN
CASE select = '1'
DO MHDRUG
CLOSE DATABASES
CASE select = '2'
repeat3 = .T.
CLOSE DATABASES
DO MHSRLIST
CASE select = '3'
repeat3 = .T.
CASE select = '4'
choice = [ ]
search2 = .T.
repeat1 = .T.
repeat3 = .F.
ENDCASE
ENDDO WHILE repeat3
ENDDO WHILE repeat1
RETURN